﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ZhimeiSoft.CharmManager.Server.DAL
{
    public class EmployeeDAL_Const
    {
        public static readonly string SQL_INSERT_EMPLOYEE = @"Insert Into EmployeeInfo (EmployeeID, EName
            , ECode, ECard, EBirthday, EAddress, EMobilePhone, EFamilyPhone, EEducation, EEntryDate, EQuitDate
            , EState, EIndexCode, ESalonID, EPassword) Values (@EmployeeID, @EName, @ECode, @ECard
            , @EBirthday, @EAddress, @EMobilePhone, @EFamilyPhone, @EEducation, @EEntryDate
            , @EQuitDate, @EState, @EIndexCode, @ESalonID, @EPassword)";

        public static readonly string SQL_UPDATE_EMPLOYEE = @"Update EmployeeInfo Set EName=@EName, ECode=@ECode
            , ECard=@ECard, EBirthday=@EBirthday, EAddress=@EAddress, EMobilePhone=@EMobilePhone
            , EFamilyPhone=@EFamilyPhone, EEducation=@EEducation, EEntryDate=@EEntryDate, EQuitDate=@EQuitDate
            , EState=@EState, EIndexCode=@EIndexCode, ESalonID=@ESalonID, EPassword=@EPassword 
            Where EmployeeID=@EmployeeID";

        public static readonly string SQL_DELETE_EMPLOYEE = @"Delete from EmployeeInfo Where EmployeeID=@EmployeeID";

        public static readonly string SQL_QUERY_EMPLOYEE_STATE = @"SELECT EMPLOYEEID,ENAME ,ECODE ,ECARD ,EBIRTHDAY ,EADDRESS ,EMOBILEPHONE ,
            EFAMLIYPHONE ,EDUCATION ,ENTRYDAY ,EQUITDAY ,ESTATE ,EINDEXCODE ,SALONID  FROM  EMPLOYEEINFO WHERE ESTATE = @ESTATE";
    }
}
